| Description |
1 online resource (iii, 330 pages) : illustrations (chiefly color) |
|
text file rda |
| Note |
"Quick answers to common problems"--Cover. |
|
Includes index. |
| Contents |
Cover; Copyright; Credits; Foreword; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Installation, Deployment, and Configuration; Introduction; Deploying and configuring a standalone agent manually; Deploying a JEE ODI Agent; Configuring a standalone agent with OPMN; Deploying JDBC drivers with a JEE ODI Agent; Chapter 2: Defining the Oracle Data Integrator Security; Introduction; Setting up LDAP security for Oracle Data Integrator; Setting external authentication with Oracle Data Integrator; Creating users using generic profiles. |
|
Creating users using non-generic profilesCreating new custom profiles in the Security navigator; Chapter 3: Advanced Topology; Introduction; Creating a new technology; Modifying actions to get more from your diagrams; Modifying and expanding datatypes; Changing the case sensitivity for code generation; Best practice -- using the Staging Area User to access your target schema; Chapter 4: Using Variables; Introduction; Passing start-up parameters to a scenario using variables; Using table names that run in all contexts using getObjectName; Using variables to filter data based on a timestamp. |
|
Using variables in KM options (and reusing the variables in an interface, package, and so on); Using variables in topology; Using variables to control loops inside packages; Chapter 5: Knowledge Module Internals; Introduction; Using the substitution passes; Using Java variables in KMs; Using Java for condition code generation; Invoking Java from the KMs; Using substitution methods in Java; Combining substitution methods in a KM; Chapter 6: Inside Knowledge Modules -- SCD and CDC; Introduction; Implementing Slowly Changing Dimensions (SCD) using ODI. |
|
Modifying a Slowly Changing Dimension KM to allow undefined behaviorsUsing Changed Data Capture (CDC) -- simple; Using Changed Data Capture (CDC) -- consistent set; Using one single interface to load changes that occur in any dimensions; Chapter 7: Advanced Coding Techniques; Introduction; Using diagrams to develop and maintain models; Generating DDL from data models; Generating interfaces from data models or diagrams; Creating a temporary interface (subquery); Loading data from an SQL query; Performing a pivot; Loading data using partition exchange; Chapter 8: Package Loops and File Processing. |
|
IntroductionDefining packages and loops for near real-time execution using a hybrid loop; Using a file from a parameter variable; Detecting files with a variable name; Processing all files in a directory; Processing a large number of files in parallel; Chapter 9: XML and Web Services; Introduction; Defining a connection to XML within ODI; Processing complex files with ODI; Processing XML data within an RDBMS not in memory; Invoking web services from ODI; Invoking asynchronous ODI web services with callbacks; Configuring container-based authentication with ODI web services. |
| Summary |
Written as a practical Cookbook, the recipes in this essential guide will help you make the most out of Oracle Data Integrator 11g. This book is meant for people who already possess a basic understanding of Oracle Data Integrator and want to take it to the next level by learning how to better leverage advanced ODI features and functionality as they continue to develop and manage their data integration projects. |
| Access |
Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK). WlAbNL |
| Terms Of Use |
Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force. WlAbNL |
| Subject |
Oracle (Computer file)
|
|
Oracle (Computer file) |
|
Oracle (Computer file) |
|
Data integration (Computer science)
|
|
Intégration de données (Informatique) |
|
Data integration (Computer science) |
| Added Author |
Dupupet, Christophe.
|
| Other Form: |
Print version: Dupupet, Christophe. Oracle Data Integrator 11g Cookbook. Birmingham : Packt Publishing, ©2013 9781849681742 |
| ISBN |
9781849681759 (electronic bk.) |
|
1849681759 (electronic bk.) |
|
More Resources